package com.example.demo.mapper;

import com.example.demo.domain.SgBStoTobOutNotices;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author OSE000196
* @description 针对表【sg_b_sto_tob_out_notices(TOB出库通知单)】的数据库操作Mapper
* @createDate 2024-10-12 17:54:05
* @Entity com.example.demo.domain.SgBStoTobOutNotices
*/
@Mapper
public interface SgBStoTobOutNoticesMapper extends BaseMapper<SgBStoTobOutNotices> {
    @Select({
            "<script>",
            " SELECT ",
            " * ",
            " FROM ",
            " sg_b_sto_tob_out_notices ",
            " WHERE ",
            " ISACTIVE = 'Y' and id > 1845703553338753026",
            "<choose>",
            "<when test='bill_status > 3'>",
            " limit 10  ",
            "</when>",
            "</choose>",
            "</script>",
    })
    List<SgBStoTobOutNotices> testWhen();

}



